Inventory Audit Trail

Report Parameters

Field

Description

Report Name

The name of the report.

Start Date

The start date from when the data must be considered for generating the report.

End Date

The end date until when the data must be considered for generating the report.

Search by Item #

Enter the item number to search the preferred item.

Search by Description

Enter the item description to search the preferred item.

Search by Supplier

Enter the name of the supplier to search the preferred item.

Search by Bar Code #

Enter the bar code scanner number to search the preferred item.

Search by Other Scanner Code

Enter other scanned codes (if any) to search the preferred item.

Category

A list of all available categories for report selection.

Sub Category 1 to 5

A list of all the available subcategories based on the selected category are displayed.

Search by Supplier Item #

Enter the supplier item number to search the preferred item.

Purchase Order #

Enter the purchase order number to search the preferred item.

Include Inactive Items

When enabled, includes inactive items in the report.

Include Non-inventory Items

When enabled, includes all non-inventory items in the report.

Sample Report

Table

Description automatically generated

Report Fields

Field

Description

Date

The transaction date of the item(s).

Time

The transaction time of the item(s).

User

The name of the user.

Qty

The number of items available.

Adjusted

The available or adjusted number of item(s).

Running Total

The on-hand quantity of the item(s).

Description

The transaction details of the item(s)- return, void, transferred or sold.

Outlet

The name of the associated outlet.

Starting Qty

The initial quantity on hand of the items in the outlet.

Current Qty

The updated quantity on hand of the items in the outlet.

On Order

The quantity of items ordered.